<?php



include_once APPLICATION_DIR.'/application/model/dao/interfaces/IPointSaleStmt.class.php';

class PointSaleStmt implements IPointSaleStmt{
    
    public function prepareSelectAllValidPointSale(){
        return " SELECT rz_point_sale.*,rz_country.NAME AS COUNTRY_NAME,rz_city.NAME AS CITY_NAME  
            FROM rz_point_sale 
            INNER JOIN rz_country ON rz_country.ID = rz_point_sale.COUNTRY_ID 
            INNER JOIN rz_city ON rz_city.ID = rz_point_sale.CITY_ID 
            WHERE rz_point_sale.ENABLED IS NOT NULL ORDER BY NAME ASC " ;
    }
}
